CREATE TABLE [dbo].[Product_Inventory]
(
[PRODUCT_CODE] [varchar] (31) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Inventory_PRODUCT_CODE] DEFAULT (''),
[QUANTITY_ON_HAND] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Inventory_QUANTITY_ON_HAND] DEFAULT ((0)),
[QUANTITY_RESERVED] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Inventory_QUANTITY_RESERVED] DEFAULT ((0)),
[QUANTITY_COMMITTED] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Inventory_QUANTITY_COMMITTED] DEFAULT ((0)),
[QUANTITY_AVAILABLE] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Inventory_QUANTITY_AVAILABLE] DEFAULT ((0)),
[QUANTITY_BACKORDERED] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Inventory_QUANTITY_BACKORDERED] DEFAULT ((0)),
[QUANTITY_ON_ORDER] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Inventory_QUANTITY_ON_ORDER] DEFAULT ((0)),
[EXPECTED_ARRIVAL_DATE] [datetime] NULL,
[LTD_ORDERS] [int] NOT NULL CONSTRAINT [DF_Product_Inventory_LTD_ORDERS] DEFAULT ((0)),
[LTD_QUANTITY] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Inventory_LTD_QUANTITY] DEFAULT ((0)),
[LTD_CANCELED_QUANTITY] [numeric] (15, 4) NOT NULL CONSTRAINT [DF_Product_Inventory_LTD_CANCELED_QUANTITY] DEFAULT ((0)),
[LTD_INCOME] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_Inventory_LTD_INCOME] DEFAULT ((0)),
[LTD_COST] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_Inventory_LTD_COST] DEFAULT ((0)),
[STANDARD_COST] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_Inventory_STANDARD_COST] DEFAULT ((0)),
[LATEST_COST] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_Inventory_LATEST_COST] DEFAULT ((0)),
[AVERAGE_COST] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_Inventory_AVERAGE_COST] DEFAULT ((0)),
[TOTAL_COST] [numeric] (15, 2) NOT NULL CONSTRAINT [DF_Product_Inventory_TOTAL_COST] DEFAULT ((0)),
[LAST_ORDER_DATE] [datetime] NULL,
[FIRST_ORDER_DATE] [datetime] NULL,
[LAST_RECEIVED_DATE] [datetime] NULL,
[MINIMUM_ORDER_POINT] [int] NOT NULL CONSTRAINT [DF_Product_Inventory_MINIMUM_ORDER_POINT] DEFAULT ((0)),
[MINIMUM_ORDER_QUANTITY] [int] NOT NULL CONSTRAINT [DF_Product_Inventory_MINIMUM_ORDER_QUANTITY] DEFAULT ((0)),
[LOCATION] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Inventory_LOCATION] DEFAULT (''),
[BIN] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Inventory_BIN] DEFAULT (''),
[INCOME_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Inventory_INCOME_ACCOUNT] DEFAULT (''),
[INVENTORY_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Inventory_INVENTORY_ACCOUNT] DEFAULT (''),
[COG_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Inventory_COG_ACCOUNT] DEFAULT (''),
[ADJUSTMENT_ACCOUNT] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL CONSTRAINT [DF_Product_Inventory_ADJUSTMENT_ACCOUNT] DEFAULT (''),
[TIME_STAMP] [timestamp] NULL
) ON [PRIMARY]

GO
ALTER TABLE [dbo].[Product_Inventory] ADD CONSTRAINT [PK_Product_Inventory] PRIMARY KEY CLUSTERED ([PRODUCT_CODE], [LOCATION]) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [iProduct_InventoryLOCATION] ON [dbo].[Product_Inventory] ([LOCATION]) ON [PRIMARY]
GO
GRANT REFERENCES ON  [dbo].[Product_Inventory] TO [IMIS]
GRANT SELECT ON  [dbo].[Product_Inventory] TO [IMIS]
GRANT INSERT ON  [dbo].[Product_Inventory] TO [IMIS]
GRANT DELETE ON  [dbo].[Product_Inventory] TO [IMIS]
GRANT UPDATE ON  [dbo].[Product_Inventory] TO [IMIS]
GO